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