UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qhKfpr470gHWuulNSbG+QSbXiyiP3FtcN1bVdm7Tqh0='
WHERE
key_id = 'cfaa487e3d8aaaf3aa7fbe7e640055e480fd6d05bd4cc5be1ecb9ed3a774c67a'
AND (
token = 'qhKfpr470gHWuulNSbG+QSbXiyiP3FtcN1bVdm7Tqh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)