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