UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iN3KZDEfmF6IO1qbxvygQABvsDja+GX2YaOAbYAYbdI='
WHERE
key_id = '0f746201d7554761546c6371092328da2f1fd6ef8591727520d5e95424ea4f7e'
AND (
token = 'iN3KZDEfmF6IO1qbxvygQABvsDja+GX2YaOAbYAYbdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)