UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/4KgG0aQhGZStB59ui28oSK8YQSfYh9Q/vgwcFD8OIA='
WHERE
key_id = '3badba5ac25d6fd28bce9b06297050ee54372a4140f081e6f80665496d2ee8b9'
AND (
token = '/4KgG0aQhGZStB59ui28oSK8YQSfYh9Q/vgwcFD8OIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)