UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VPIy5Kwal4tbCfWLBfGJu1sh+8EmuPY3GZr9vXEaw2A='
WHERE
key_id = '3d9cb433eedbd0daf0f4c2f0c0f5e6cfe1d86ede4f853f899cfcc26fa47672a3'
AND (
token = 'VPIy5Kwal4tbCfWLBfGJu1sh+8EmuPY3GZr9vXEaw2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)