UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZvfwVt+51EFIRljueRa/SW76exqI5Wfk+M9vir3Yho='
WHERE
key_id = '46b765261250f229a300e071a25c80990bc828358020939b78b4df6dc2932eac'
AND (
token = 'XZvfwVt+51EFIRljueRa/SW76exqI5Wfk+M9vir3Yho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)