UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3idLsITOl81ON86nJ8+3htXsyWOjqRRokc6G9TRuEAs='
WHERE
key_id = '1f19d20ba33ea2ef67deef37740cc9f559c86d12b4924349435147884e2adfaa'
AND (
token = '3idLsITOl81ON86nJ8+3htXsyWOjqRRokc6G9TRuEAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)