UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q6zId2soiaAfsiphFg/NW+s4BgdzH7SNSua5XzByLx0='
WHERE
key_id = '9fbe13eee6f2863be6898ec446374af6b9afbc44a4b41b8a7a1cfe7d02b2df54'
AND (
token = 'q6zId2soiaAfsiphFg/NW+s4BgdzH7SNSua5XzByLx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)