UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q16FGCMcCsyx2wVgUi43wH/zKmhzokcdYQKI1pI3XZU='
WHERE
key_id = '3a07a419577fc1cca1a2412ce766566bc0b0a3088cd3a147374154baec47450f'
AND (
token = 'q16FGCMcCsyx2wVgUi43wH/zKmhzokcdYQKI1pI3XZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)