UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OaS9t4OUB2ydmIDuMWbAwTDJGyk2iitmoWe/xD1OXU0='
WHERE
key_id = 'b7a7167bbef89a7b16b00a5e2296d13809fbac5ae9ff4e729f13d592a373c7ec'
AND (
token = 'OaS9t4OUB2ydmIDuMWbAwTDJGyk2iitmoWe/xD1OXU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)