UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '30D1z7h2fmXmXBIOcVMu4eyI84qN8cfl8NdAQQocg/o='
WHERE
key_id = '0ea457b87332159b0406d5f4c6f6c8b282c70503df8f8f73e4957f459fa6ab40'
AND (
token = '30D1z7h2fmXmXBIOcVMu4eyI84qN8cfl8NdAQQocg/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)