UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k0NHFWkbkeSL5BRIoniTiM5Mvu3QMXO26zgJ6vNfLpg='
WHERE
key_id = '111eea1d4c919580e05e8535fb5ab0aa30ab39137ca7a6f525f0e81b6fc2be5f'
AND (
token = 'k0NHFWkbkeSL5BRIoniTiM5Mvu3QMXO26zgJ6vNfLpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)