UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tgZYpQv4viMY4zE7zv0FXHdB/I/N8Zy1xxoPxjf71lI='
WHERE
key_id = '16c255095df27a9aef554672a40cad2e57143be3a70e8f090ff283bac0d87bd6'
AND (
token = 'tgZYpQv4viMY4zE7zv0FXHdB/I/N8Zy1xxoPxjf71lI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)