UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O1lD67ziNmp5g1GN15qrNM6DiS0Ows/rWnNBr+piG8g='
WHERE
key_id = '45fefc127b6a4ee48de6ab24a47ff623115038dda74df35297178a9823b2b91e'
AND (
token = 'O1lD67ziNmp5g1GN15qrNM6DiS0Ows/rWnNBr+piG8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)