UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vVTW8d57P/zYyldqYlYbG45jrwB6maPt2trVhjJ+wXM='
WHERE
key_id = 'abe68fbf8c94a3a919aa2d3b6f9e3d124e74134769b4cc246f6e30174acdd3dc'
AND (
token = 'vVTW8d57P/zYyldqYlYbG45jrwB6maPt2trVhjJ+wXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)