UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hXpUjgsTBcTRu7i//HQRHs79ip2FsQzzdsUXLoSGLmE='
WHERE
key_id = '2bbf991287c1078d843246adbbfc8dcbf117621f30acaa88e3247d0be4026a15'
AND (
token = 'hXpUjgsTBcTRu7i//HQRHs79ip2FsQzzdsUXLoSGLmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)