UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kP7NxnFcu4hIFa3o/mhap1K0W0JS3A/n7hFHWtiq6jQ='
WHERE
key_id = '3ddafd74aa16e5d3d6c04b55683906114e244e228119f52b3f5d54b5157538f0'
AND (
token = 'kP7NxnFcu4hIFa3o/mhap1K0W0JS3A/n7hFHWtiq6jQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)