UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42x+lcQHMIQ4iFkrFVSzw1LhL4oYVBN92oCTvPUMyWc='
WHERE
key_id = '5e49ff6c35183bb42fe886921cdde05d7d15a9c02acbc47a97de5f35e8b28e4b'
AND (
token = '42x+lcQHMIQ4iFkrFVSzw1LhL4oYVBN92oCTvPUMyWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)