UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNVlBPMmGEOZ13Xd+jLdsoRbnm840kHayPZZcsZDsA8='
WHERE
key_id = '7c767295d12781bc421b58b2c97e840f870d6de06d5db1706fac216faea89d43'
AND (
token = 'ZNVlBPMmGEOZ13Xd+jLdsoRbnm840kHayPZZcsZDsA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)