UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o6wEHDW45kBacFWUs73VpKpsX5V0Gg5TUtWjHVQ1aM8='
WHERE
key_id = 'c13a4f22c3e3e1799b167454c067b13a6b0a18ffbf01e1bffbddc36e5f951767'
AND (
token = 'o6wEHDW45kBacFWUs73VpKpsX5V0Gg5TUtWjHVQ1aM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)