UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B28H9PEsqUNr/YkExeVYcjWqIeUC0umQqk84IMJChwM='
WHERE
key_id = 'a73edbf867e35939289dad34f0f980a93100cb6d39a5704fb315a815a4a0ff4d'
AND (
token = 'B28H9PEsqUNr/YkExeVYcjWqIeUC0umQqk84IMJChwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)